Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | AggregateItem(AS_ITM_AGGT) |
MemberItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM_MBR | IdentityUUID | char(32) | Item(AS_ITM) |
SequenceNumber | Assigns a sequence / sorting order for the items in the collection. | AI_ITM_CLN | LineNumber | smallint | |
PerAssemblyCount | The number of individual member Items that are assembled into the AggregateItem or Kit. | QU_ITM_PR_ASMB | Quantity | DECIMAL(9,3) | |
BlendPercent | The percentage of the parent item that comes from the child item. | PE_BLD | Percent | decimal(7,4) | |